home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
SPREOTUS
/
SPEDCORS.LZH
/
L61A
< prev
next >
Wrap
Text File
|
1992-06-07
|
3KB
|
136 lines
1Monday ╔══════════════════╗
║ LOTUS PIE GRAPH ║
╚══════════════════╝
In this Lesson you will make a BAR graph, a PIE graph, a Line graph,
and a Stack-Bar.
▀ The Lesson will be saved on your disk and named MONDAY.
TO BEGIN
▀ Type Table (Figure 12-3) on page ss7.
▀ In Cell C8 type Formula @SUM(C1..C6)
▀ IN CELL D8 type Formula @SUM(D1..D6)
▀ IN CELL E8 TYPE FORMULA @SUM(E1..E6)
MAKING THE GRAPHS
▀ Press / G (for graph)
▀ "Type" appears. Press Enter key.
▀ Press B (for Bar)
CREATING THE RANGE
▀ Press X Type RANGE C1..C1 Press Enter.
▀ Press A Type range C1..C6 Press Enter.
▀ Press B Type range D1..D6 Press Enter.
▀ Press C Type range E1..E6 Press Enter.
TO VIEW BAR GRAPH
▀ Press V (for view).
▀ The Bar graph appears six groups of bars.
▀ The first group of 3 bars are C1, B1, and E1.
▀ The second group of 3 bars represents C2, D2, and E2.
▀ The 6th group represents C6 (175), D6 (286), and E6 (461).
CHANGING FROM BAR GRAPH TO PIE GRAPH
▀ From the Bar GRAPH on the screen.....
▀ Press (/). Returns you to Menu with View.
▀ Press T (for Type).
▀ Press P (for Pie).
▀ Press V ( for View).
A Pie-shaped graph appears on the screen. Note graph appears with two
segments separated from Pie.
TO SAVE GRAPH
▀ Press (/).
▀ Press Esc key twice. Returns to Control Menu.
▀ Press F (for file), S (for save).
▀ You should be in the A directory. (Your disk in the A drive).
▀ Type Monday
▀ Press Enter... File is saved on disk in A drive as Monday.WK1.
Press (/) or Esc key to return to Control Panel and Table of figures.
- 33 -
TO ADD 2 DECIMAL PLACES AND DOLLAR SIGN
▀ Move cursor to Cell C1.
▀ Press (/) or Esc to access Worksheet (Control Menu).
▀ Press R (for Range), F (for Format), C (for Currency).
▀ Two decimal places appears.
▀ Press <Enter> key.
▀ Screen displays "Enter range to Format... C1..C1"
▀ Move right arrow to E1, and then down to E8.
▀ Press <Enter> key.
▀ All numbers now have Dollar sign and 2 decimal places.
*** END OF LOTUS LESSONS ***
Press <Esc> Key To Return To Menu.
5/28/92 Pat Ferro
- 34 -